﻿CREATE TABLE [dbo].[HotelsRatings] (
    [HotelId] INT NOT NULL,
    [UserId]  INT NOT NULL,
    [Rating]  INT NOT NULL,
    CONSTRAINT [PK_HotelsRatings] PRIMARY KEY CLUSTERED ([HotelId] ASC, [UserId] ASC),
    CONSTRAINT [FK_HotelsRatings_Hotel] FOREIGN KEY ([HotelId]) REFERENCES [dbo].[Hotel] ([HotelId]),
    CONSTRAINT [FK_HotelsRatings_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId])
);

